package com.kim.rssreader.domain.constant;

public class RssColumnConstant {

	public static final String TABLE_NAME = "rss_column";

	public static final String KEY = "_id"; // 逻辑主键

	public static final String RSSCOLUMNID = "_columnid";

	public static final String RSSCOLUMNNAME = "_columnname";

	public static final String RSSCOLUMNURL = "_columnlink";

	public static final String RSSCOLUMNCUSTOMER = "_columncustomer";

	public static final String RSSCOLUMNATTENTION = "_columnattention";

	public static final String RSSCOLUMNENCODING = "_columnencoding";

	public static final String RSSCOLUMNFLAGSTART = "_columnflagstart";

	public static final String RSSCOLUMNFLAGEND = "_columnflagend";

	public static final String RSSCOLUMNCATEGORY = "_columncategory";

	public static final int COLUMN_KEY = 0; // 逻辑主键

	public static final int COLUMN_RSSCOLUMNID = 1;

	public static final int COLUMN_RSSCOLUMNNAME = 2;

	public static final int COLUMN_RSSCOLUMNURL = 3;

	public static final int COLUMN_RSSCOLUMNCUSTOMER = 4;

	public static final int COLUMN_RSSCOLUMNATTENTION = 5;

	public static final int COLUMN_RSSCOLUMNENCODING = 6;

	public static final int COLUMN_RSSCOLUMNFLAGSTART = 7;

	public static final int COLUMN_RSSCOLUMNFLAGEND = 8;

	public static final int COLUMN_RSSCOLUMNCATEGORY = 9;

	public static final String[] COLUMNS = new String[] { KEY, RSSCOLUMNID,
			RSSCOLUMNNAME, RSSCOLUMNURL, RSSCOLUMNCUSTOMER, RSSCOLUMNATTENTION,
			RSSCOLUMNENCODING, RSSCOLUMNFLAGSTART, RSSCOLUMNFLAGEND,
			RSSCOLUMNCATEGORY };

	public static final String SQL_CREATE = "CREATE  TABLE IF NOT EXISTS `rss_column` ("
			+ "`_id` INTEGER PRIMARY KEY AUTOINCREMENT ,"
			+ "`_columnid` VARCHAR(36) NOT NULL ,"
			+ "`_columnname` VARCHAR(45) NOT NULL,"
			+ "`_columnlink` VARCHAR(100) NOT NULL ,"
			+ "`_columncustomer` INTEGER ,"
			+ "`_columnattention` INTEGER ,"
			+ "`_columnencoding` VARCHAR(10),"
			+ "`_columnflagstart` VARCHAR(10),"
			+ "`_columnflagend` VARCHAR(10),"
			+ "`_columncategory` VARCHAR(36) , unique(`_columnname`) )";
}
